IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID('UserSelectByName','P'))
    DROP PROCEDURE UserSelectByName
GO
/*
 * Designer:     Kevin
 * Description:    
 * Created:      03/10/2011
 * History:
 * =============================================================================
 * Author      DateTime        Alter Description
 * =============================================================================
 */

CREATE PROCEDURE UserSelectByName
(
	@UserName NVARCHAR(100)
)
AS
BEGIN
	select 
		user_id as UserId,
		user_name as UserName,
		Password
	from
		[user](nolock)
	where [USER_NAME]=@UserName
END
GO